| 1. | Noindex does not affect system tables because integrity checks are always performed on system table indexes
Noindex不影响系统表，因为总是对系统表索引执行完整性检查。 |
| 2. | Noindex does not affect system tables because dbcc checkfilegroup always checks all system table indexes
Noindex不影响系统表，因为dbcc checkdb总是对所有系统表索引进行检查。 |
| 3. | Noindex does not affect system tables because the integrity checks are always performed on all system table indexes
Noindex不会影响系统表，因为完整性检查的执行对象始终是所有系统表索引。 |
| 4. | With that single macro , you can take away a lot of work for any program that has to generate mathematical tables indexed by integer
使用这一个宏，就可以节省很多编程的工作，它可以生成一个使用整数进行索引的数学表。 |
| 5. | However , in the absence of data distribution information , the optimizer will calculate selectivity for filters of different types based on table indexes
然而在缺乏数据分布信息的情况下，优化器将基于表索引计算不同类型筛选器的选择性。 |
| 6. | Drop table indexes to improve performance for large bulk imports . this guideline is for when you are importing a large amount of data compared to the amount of data that is already in the table
如果要加载的数据与表中已存在的数据相比数量较大，则执行大容量导入操作之前从表中删除索引将显著提高性能。 |
| 7. | The other is schema path look - up hash table index . it is used to evaluate absolute paths for general regular path expressions , such as relative path expressions , so as to relieve the workload of large scale of navigation and speed up queries
此外，为了解决主索引对于相对路径查询需要大规模遍历的问题，我们设计了模式路径哈希表作为辅助索引，用于在主索引执行相对路径查找之前计算相对路径查询的绝对路径，使主索引的遍历负荷大大减轻，从而使相对查询的效率提高。 |
